Basics

Introduction to MySQL

• What is MySQL?
• Installing and setting up MySQL
• Connecting to MySQL server

Database Fundamentals

• Creating databases and tables
• Basic SQL commands (SELECT, INSERT, UPDATE, DELETE)
• Data types in MySQL

Basic SQL Queries

• Simple SELECT statements
• Filtering data with WHERE clause
• Sorting data with ORDER BY
• Limiting data with LIMIT clause

Intermediate

Advanced SQL Queries

• Joining tables (INNER JOIN, LEFT JOIN, RIGHT JOIN)
• Subqueries and nested queries
• Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
• Grouping data with GROUP BY

Database Design

• Normalization and denormalization
• Primary keys and foreign keys
• Indexing for performance
• ER diagrams and database modeling

Stored Procedures and Functions

• Creating stored procedures
• Creating stored functions
• Using parameters in procedures and functions
• Error handling and exception management

Triggers and Events

• Creating and managing triggers
• Automating tasks with scheduled events
• Applications of triggers and events

Advanced

Performance Optimization

• Query optimization techniques
• Index optimization
• Understanding and using execution plans
• Database caching strategies

Security

• User management and permissions
• Securing connections with SSL
• Data encryption and decryption
• Backup and recovery strategies

Replication and Clustering

• Introduction to replication
• Setting up master-slave replication
• Understanding and using MySQL Cluster
• High availability solutions

Advanced Topics

• JSON data type and functions
• Full-text search
• Spatial data and GIS functions
• Working with large datasets